
[dbo].[asi_InsertChangeLog]
CREATE PROCEDURE [dbo].[asi_InsertChangeLog]
@logKey uniqueidentifier,
@orgKey uniqueidentifier,
@objectTypeName nvarchar(100),
@objectKey uniqueidentifier,
@actionType tinyint,
@desc nvarchar(250),
@createdOn datetime,
@createdByUserKey uniqueidentifier
AS
INSERT
ChangeLog (ChangeLogKey, OrganizationKey, ObjectTypeName, ObjectKey, ActionType, Description, CreatedOn, CreatedByUserKey)
VALUES
(@logKey, @orgKey, @objectTypeName, @objectKey, @actionType, @desc, @createdOn, @createdByUserKey)
GO